﻿-- =============================================
-- Script Template
-- =============================================
USE [IC.NET_NEW]
GO
SELECT 'ContentTopic' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM ContentTopic UNION
SELECT 'DistributionReference' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM DistributionReference UNION
SELECT 'EmergencyMessageContainer' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM EmergencyMessageContainer UNION
SELECT 'EmergencyMessageContent' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM EmergencyMessageContent UNION
SELECT 'ExposureCache' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM ExposureCache UNION
SELECT 'ExposureCacheRole' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM ExposureCacheRole UNION
SELECT 'ExposureCategory' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM ExposureCategory UNION
SELECT 'NonXMLContent' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM NonXMLContent UNION
SELECT 'OriginatorRole' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM OriginatorRole UNION
SELECT 'Other' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM Other UNION
SELECT 'Recipient' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM Recipient UNION
SELECT 'RecipientRole' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM RecipientRole UNION
SELECT 'SenderRole' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM SenderRole UNION
SELECT 'TargetArea' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM TargetArea UNION
SELECT 'XMLContent' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM XMLContent UNION
SELECT 'ConsumerRole' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM ConsumerRole UNION
SELECT 'ContainerTopic' AS [TABLE NAME], COUNT(*) AS [ROWS] FROM ContainerTopic
GO
